

if not exists (select * from master.dbo.syslogins where loginname = N'alice')
BEGIN
	exec sp_addlogin 'alice' ,'alice', 'MSPetShop3Redux'
END

--CREATE LOGIN alice WITH PASSWORD = 'alice',       CHECK_POLICY = OFF


exec sp_grantdbaccess 'alice'

exec sp_addrolemember 'db_owner', 'alice'

